* Create Data;

data EmpsAUUS;
   input First $ Gender $ Country $;
   datalines;
Togar	M	AU
Kylie	F	AU
Stacey	F	US
Gloria	F	US
James	M	US
;
run;

data Phones;
   input Country $ Phone $15.;
   datalines;
AU +61(2)5555-1500
AU +61(2)5555-1600
AU +61(2)5555-1700
US +1(305)555-1500
US +1(305)555-1600
;
run;

proc print data=EmpsAUUS;
run;

proc print data=Phones;
run;

* Many-to-Many;

data Empsall1;
   merge EmpsAUUS Phones;
   by Country;
run;

proc print data=Empsall1;
run;

proc sql;
   create table Empsall as
   select First, Gender, Phones.Country, Phone
   from EmpsAUUS, Phones
   where EmpsAUUS.Country=Phones.Country;
quit;

proc print data=Empsall;
run;